Constraints and Multidimensional Databases
نویسندگان
چکیده
The model we define organises data in a constellation of facts and dimensions with multiple hierarchies. In order to insure data consistence and reliable data manipulation, we extend this constellation model by intraand inter-dimension constraints. The intra-dimension constraints allow the definition of exclusions and inclusions between hierarchies of a same dimension. The inter-dimension constraints are related to hierarchies of different dimensions. Also, we study effects of these constraints on multidimensional operations. We depict integration of these constraints within GEDOOH prototype.
منابع مشابه
Towards Specialized Integrity Constraints for Spatial Datacubes
Spatial datacubes (also called "spatial multidimensional databases") are the cornerstone of the emerging Spatial On-Line Analytical Processing (SOLAP) technology. They are aimed at supporting Geographic Knowledge Discovery (GKD) as well as certain types of spatial decision-making. Although these technologies seem promising at first glance, they may provide unreliable results if one does not con...
متن کاملFrom Transactional Spatial Databases Integrity Constraints to Spatial Datacubes Integrity Constraints
Spatial multidimensional databases (also called "spatial datacubes") are the cornerstone of the emerging Spatial On-Line Analytical Processing technology (SOLAP). They are aimed at supporting Geographic Knowledge Discovery (GKD) as well as certain types of spatial decision-making. Although these technologies seem promising at first glance, they may provide unreliable results if one does not con...
متن کاملAn Integrity Constraints Language for a Conceptual Multidimensional Data Model
A number of models for conceptual design of multidimensional databases have been proposed but only a few of them support the notion of integrity constraints. This work introduces a Conceptual Multidimensional Data Model, which supports a generic constraint language and a high-level data structure. Also, a graphical notation for structures and constraints is
متن کاملHierarchy integration in the design of data warehouses
Face to their merger and/or collaboration with partners, today’s enterprises often need to integrate several databases. As a result, their decision making process ends up analyzing data coming from various databases. While database integration has been thoroughly examined, it is only recently that the integration of multidimensional models has drawn attention. A multidimensional model is a data...
متن کاملContraintes pour modèle et langage multidimensionnels
This paper defines a constraint-based model dedicated to multidimensional databases. The model we define represents data through a constellation of facts (subjects of analyse) associated to dimensions (axis of analyse), which are possibly shared. Each dimension is organised according to several hierarchies (views of analyse) integrating several levels of data granularity. In order to insure dat...
متن کاملذخیره در منابع من
با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید
عنوان ژورنال:
دوره شماره
صفحات -
تاریخ انتشار 2003